.. _`HJoin Tables`:

.. _`org.sysess.sympathy.data.table.hjointablessingle`:

HJoin Tables
````````````

.. image:: hjoin_table.svg
   :width: 48


HJoin a list of Tables into a single Table, stacking columns next to each other




Documentation
:::::::::::::

The operation of horizontal join, or HJoin, stacks the columns in the incoming
Tables horizontally, next to each other. The colunms in the output Table will
be union of columns from the input Tables.

If the option 'Complement missing rows' is unchecked (the default) then all the
inpnut Tables must have the same number of rows. Otherwise, Tables with fewer
rows are padded with masked values.


If a column name exists in more than one input Table such columns from Tables
later in the list will take precedence and the corresponding columns from Table
earlier in the list will be lost.


Table name
==========
The node always tries to give the output table a name, so if the chosen
port has a table without name, the other port will be used. This is
to preserve backwards compatibility.


Definition
::::::::::


Input ports
===========

    **port1**  [table]
        Input Tables


Output ports
============

    **port1**  table
        Table with horizontally joined data from the incoming list of Tables.




Configuration
=============

    **Complement missing rows** (mask)
        Select if rows that are not represented in all Tables should be complemented with masked values
    **Rename duplicate columns** (rename)
        If true columns with same name as an earlier column will be renamed and joined, otherwise columns will overwrite existing data





Related nodes
=============

* :ref:`org.sysess.sympathy.data.table.hjointable`

* :ref:`org.sysess.sympathy.data.table.hjointables`

* :ref:`org.sysess.sympathy.data.table.hsplittablenode`




Examples
========

* :download:`HJoinTable.syx </Examples/Sympathy/Data Processing/Structure/HJoinTable.syx>`




Implementation
==============

.. automodule:: node_hjoin_tables
    :noindex:

.. class:: HJoinTablesSingle
    :noindex: